﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="consultaProceIncop.aspx.cs" Inherits="WebContratos.consultaProceIncop" %>


<%@ Register assembly="DevExpress.Web.ASPxGridView.v10.2, Version=10.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxGridView" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.ASPxEditors.v10.2, Version=10.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dx" %>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
    <title>Página sin título</title>
    
    
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <dx:ASPxGridView ID="ASPxGridView1" runat="server" AutoGenerateColumns="False" 
            CssFilePath="~/App_Themes/Aqua/{0}/styles.css" CssPostfix="Aqua" 
            DataSourceID="SqlDataSource1" Width="100%">
            <Styles CssFilePath="~/App_Themes/Aqua/{0}/styles.css" CssPostfix="Aqua">
                <LoadingPanel ImageSpacing="8px">
                </LoadingPanel>
            </Styles>
            <SettingsLoadingPanel ImagePosition="Top" />
            <ImagesFilterControl>
                <LoadingPanel Url="~/App_Themes/Aqua/Editors/Loading.gif">
                </LoadingPanel>
            </ImagesFilterControl>
            <Images SpriteCssFilePath="~/App_Themes/Aqua/{0}/sprite.css">
                <LoadingPanelOnStatusBar Url="~/App_Themes/Aqua/GridView/gvLoadingOnStatusBar.gif">
                </LoadingPanelOnStatusBar>
                <LoadingPanel Url="~/App_Themes/Aqua/GridView/Loading.gif">
                </LoadingPanel>
            </Images>
            <Columns>
               <dx:GridViewDataTextColumn Caption="Incop" VisibleIndex="1" FieldName="KeyField2" >
                    <DataItemTemplate>
                        <a href="<%# Eval("URL") %>"><img src='images/editar.jpg' title="Ver Informacion del Incop" /></a></DataItemTemplate>
                </dx:GridViewDataTextColumn>              
                
                <dx:GridViewDataTextColumn Caption="Codigo de Proceso" VisibleIndex="1" FieldName="KeyField2" >
                    <DataItemTemplate>
                        <a href="ingresoContratos.aspx?codProceso=<%# Eval("CODIGO_PROCESO") %>&usr=<%=usr%>&pwd=<%=pwd%>&exP=<%=exP%>&email=<%=email%>&tipo=CONSULTA"><%#Eval("CODIGO_PROCESO")%></a></DataItemTemplate>
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="TIPO" Caption="Contrato Ingresado?" VisibleIndex="2">
                </dx:GridViewDataTextColumn>
                
                
                
                <dx:GridViewDataTextColumn FieldName="CODIGO_PROCESO" Caption="Codigo de Proceso" VisibleIndex="1" Visible="false">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="OBJETO_PROCESO" Caption="Objeto del Proceso" VisibleIndex="2">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="CATALOGO_DESCRIPCION" Caption="Estado del Proceso" VisibleIndex="3">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="PRESUPUESTO" Caption="Presupuesto del Proceso" VisibleIndex="4">
                </dx:GridViewDataTextColumn>
                
                <dx:GridViewDataDateColumn FieldName="URL" Caption="Url del Incop" VisibleIndex="5" Visible=false>
                </dx:GridViewDataDateColumn>
                
                <dx:GridViewDataDateColumn FieldName="FECHA_PUBLICACION" Caption="Fecha del Proceso" VisibleIndex="5">
                </dx:GridViewDataDateColumn>
                
            </Columns>
            <Settings ShowFilterRow="True" />
            <StylesEditors>
                <CalendarHeader Spacing="1px">
                </CalendarHeader>
                <ProgressBar Height="25px">
                </ProgressBar>
            </StylesEditors>
            <ImagesEditors>
                <DropDownEditDropDown>
                    <SpriteProperties HottrackedCssClass="dxEditors_edtDropDownHover_Aqua" 
                        PressedCssClass="dxEditors_edtDropDownPressed_Aqua" />
                </DropDownEditDropDown>
                <SpinEditIncrement>
                    <SpriteProperties HottrackedCssClass="dxEditors_edtSpinEditIncrementImageHover_Aqua" 
                        PressedCssClass="dxEditors_edtSpinEditIncrementImagePressed_Aqua" />
                </SpinEditIncrement>
                <SpinEditDecrement>
                    <SpriteProperties HottrackedCssClass="dxEditors_edtSpinEditDecrementImageHover_Aqua" 
                        PressedCssClass="dxEditors_edtSpinEditDecrementImagePressed_Aqua" />
                </SpinEditDecrement>
                <SpinEditLargeIncrement>
                    <SpriteProperties HottrackedCssClass="dxEditors_edtSpinEditLargeIncImageHover_Aqua" 
                        PressedCssClass="dxEditors_edtSpinEditLargeIncImagePressed_Aqua" />
                </SpinEditLargeIncrement>
                <SpinEditLargeDecrement>
                    <SpriteProperties HottrackedCssClass="dxEditors_edtSpinEditLargeDecImageHover_Aqua" 
                        PressedCssClass="dxEditors_edtSpinEditLargeDecImagePressed_Aqua" />
                </SpinEditLargeDecrement>
            </ImagesEditors>
        </dx:ASPxGridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
            SelectCommand="SELECT '~/images/editar.jpg' as image,t.*, w.catalogo_descripcion, decode(
nvl((
select '1' VALOR from t_contrato , t_datos_incop d
where  trim(observacion) = d.codigo_proceso and url is not null
and trim(observacion) = T.CODIGO_PROCESO AND ROWNUM = 1),'NO INGRESADO'),'NO INGRESADO','NO INGRESADO','INGRESADO') TIPO
 FROM T_DATOS_INCOP t, web_catalogo w where t.ESTADO_PROCESO = 'AD' and w.catalogo_nombre = 'TIPINCOPPRO' and catalogo_codigo = t.ESTADO_PROCESO and t.url is not null "></asp:SqlDataSource>
    
        
    </div>
    </form>
</body>
</html>
